[ODBC Microsoft Access Driver] 标准表达式中数据类型不匹配

来源：百度知道编辑：UC知道时间：2024/05/18 09:58:58

dgstatus();
</SCRIPT>
<BODY oncontextmenu="return false;" oncopy=document.selection.empty(); bgColor=#1A2942 leftMargin=0 topMargin=0 onselect=document.selection.empty();><DIV align=center> <TABLE cellSpacing=1 cellPadding=0 width=150 border=0><TBODY><TR><TD colSpan=2 height=5></TD></tr>
<%
52行 Set Rs=Conn.Execute("Select * From down where hy="&clng(request("hy"))&" order by hits desc")
i = 0
Do While Not rs.EOF
i = i + 1
%>
<tr><TD vAlign=top width=5 height=10></td><TD width=145 height=20 style="word-break:break-all;">·<A href="tv/<%=rs("id")%>.htm" ><%=rs("cxn")%></a></TD></tr>
<%
rs.movenext
Loop
Set Rs=nothing
Set Conn=nothing
%>
上面的52行说数据类型不匹配浏览器上为？hy=生活急用

Set Rs=Conn.Execute("Select * From down where hy="&clng(request("hy"))&" order by hits desc")

数据库中hy字段和request("hy")不符.request("hy")应是文本类型.将数据库中HY改成文本类型.

八懂